package com.geekbang.lul.consumer.mapper;

import com.geekbang.lul.dto.CustomerBalanceFreezeDTO;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;


/**
 * @author nhsoft.lul
 */
public interface CustomerBalanceFreezeMapper {

    @Select("insert into customer_balance_freeze(customer_id, cnh_freeze, usd_freeze) values (#{customerId}, #{cnhFreeze}, #{usdFreeze})")
    void save(CustomerBalanceFreezeDTO customerBalanceFreezeDTO);

    @Delete("delete from customer_balance_freeze where customer_id = #{customerId}")
    void delete(Integer customerId);
}
